<?php
header ("Content-Type:text/html");
include ('cnn/cnn.php');
$cnn = cnn2();
$anio=$_REQUEST['anio'];
$mes=$_REQUEST['mes'];
$dia=$_REQUEST['dia'];
$sq="call consulta_registro_resultados(".$anio.",".$mes.",".$dia.");";
/*echo "<?html version=\"1.0\" encoding=\"utf-8\"?>";*/
//echo $anio." ".$mes." ".$dia;
echo "<table>";
//echo "<root>";
echo "<tr><th style='border:blue 1px solid;'>No</th><th style='border:blue 1px solid;'>Nombre</th><th style='border:blue 1px solid;'>E-Mail</th><th style='border:blue 1px solid;'>Escuela</th><th style='border:blue 1px solid;'>Fecha</th></tr>";
$sql=mysqli_query($cnn,$sq) or die("Error: ".mysqli_error($cnn));
$n=1;
while($res=mysqli_fetch_object($sql)){
    echo "<tr>";
    echo "<td style='border:blue 1px solid;'>".($n++)."</td>";
    echo "<td style='border:blue 1px solid;'><input type='hidden' value=".$res->idregistro."><a href=# onClick=\"popup_vista_h('Consulta_Vocacion.php?asp=".$res->idregistro."')\">".utf8_encode($res->txtNombre)."</td>";
    echo "<td style='border:blue 1px solid;'>".$res->txtEmail."</td>";
    echo "<td style='border:blue 1px solid;'>".$res->txtEscuela."</td>";
    echo "<td style='border:blue 1px solid;'>".$res->Fecha."</td>";
    echo "</tr>";/*
    echo "<t1>".utf8_encode($res->txtNombre)."</t1>";
    echo "<t2>".utf8_encode($res->txtEmail)."</t2>";
    echo "<t3>".utf8_encode($res->txtEscuela)."</t3>";*/
}
//echo "</root>";
echo "</table>";


?>
